--------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\cristb\Portfolio allocation France\Replication materials\stata_table2.log
  log type:  text
 opened on:  18 Mar 2016, 11:38:04

. do "C:\Users\cristb\Portfolio allocation France\Replication materials\stata_table2.do"

. version 13.0

. #delimit ;
delimiter now ;
. set more off;

. *     ***************************************************************** *;
. *     ***************************************************************** *;
. *       File-Name:  stata_table2.do                                     *;
. *       Date:       March 18, 2016                                      *;
. *       Author:     Cristina Bucur                                      *;
. *       Purpose:    Produce Table 2 in Party Politics article paper     *;
. *       Input File:     governments_france5.dta                         *;
. *       Output File:    stata_table2.log                                *;
. *     ****************************************************************  *;
. *									  *;
. *									  *;
. *     ****************************************************************  *;
. *       Produce the results shown in Tables 2                           *;
. *     ****************************************************************  *;

. reg govshare1 expectedgovshare if govno>=22 & party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 2467.86
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9615
                                                       Root MSE      =  .05963

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
       govshare1 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   .9662095   .0194496    49.68   0.000     .9267638    1.005655
           _cons |   .0120284   .0063405     1.90   0.066    -.0008308    .0248876
----------------------------------------------------------------------------------

. reg reciprocal expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 2785.51
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9408
                                                       Root MSE      =   .0834

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
      reciprocal |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |    1.07706   .0204074    52.78   0.000     1.035672    1.118448
           _cons |  -.0284265   .0075226    -3.78   0.001     -.043683   -.0131699
----------------------------------------------------------------------------------

. reg reciprocal2 expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1192.77
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.8383
                                                       Root MSE      =  .16555

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
     reciprocal2 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   1.221259   .0353613    34.54   0.000     1.149543    1.292976
           _cons |  -.0758066   .0134135    -5.65   0.000    -.1030105   -.0486027
----------------------------------------------------------------------------------

. reg linear expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1939.82
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9570
                                                       Root MSE      =  .06561

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
          linear |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   1.003089    .022775    44.04   0.000     .9568991    1.049279
           _cons |  -.0035888   .0075916    -0.47   0.639    -.0189853    .0118076
----------------------------------------------------------------------------------

. reg exp_12 expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1627.78
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9321
                                                       Root MSE      =    .089

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
          exp_12 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   1.068768   .0264902    40.35   0.000     1.015043    1.122493
           _cons |   -.027847    .009363    -2.97   0.005     -.046836    -.008858
----------------------------------------------------------------------------------

. reg exp_25 expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 2202.87
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9548
                                                       Root MSE      =  .06851

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
          exp_25 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   1.020011   .0217325    46.93   0.000     .9759352    1.064086
           _cons |   -.009797   .0074829    -1.31   0.199    -.0249731    .0053791
----------------------------------------------------------------------------------

. reg exp_50 expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 2618.98
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9634
                                                       Root MSE      =  .05975

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
          exp_50 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   .9928469   .0194007    51.18   0.000     .9535006    1.032193
           _cons |   .0007951   .0066148     0.12   0.905    -.0126202    .0142105
----------------------------------------------------------------------------------

. reg exp_75 expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 2677.24
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9645
                                                       Root MSE      =  .05825

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
          exp_75 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   .9834443   .0190067    51.74   0.000     .9448969    1.021992
           _cons |   .0045462   .0064205     0.71   0.483    -.0084751    .0175675
----------------------------------------------------------------------------------

. reg reciprocal_avg expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1657.41
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9428
                                                       Root MSE      =  .08105

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
  reciprocal_avg |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   1.066566   .0261983    40.71   0.000     1.013433    1.119698
           _cons |   -.023508    .008555    -2.75   0.009    -.0408583   -.0061578
----------------------------------------------------------------------------------

. reg reciprocal2_avg expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1055.15
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.8518
                                                       Root MSE      =  .15271

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
 reciprocal2_avg |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |    1.18625    .036519    32.48   0.000     1.112186    1.260314
           _cons |  -.0629149   .0126755    -4.96   0.000    -.0886219   -.0372079
----------------------------------------------------------------------------------

. reg linear_avg expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1356.53
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9558
                                                       Root MSE      =   .0665

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
      linear_avg |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   1.002032   .0272061    36.83   0.000     .9468557    1.057209
           _cons |  -.0009885   .0087274    -0.11   0.910    -.0186885    .0167115
----------------------------------------------------------------------------------

. reg exp_12_avg expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1230.64
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9430
                                                       Root MSE      =  .07959

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
      exp_12_avg |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   1.048847   .0298983    35.08   0.000     .9882104    1.109483
           _cons |  -.0183717   .0097284    -1.89   0.067    -.0381017    .0013584
----------------------------------------------------------------------------------

. reg exp_25_avg expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1371.22
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9547
                                                       Root MSE      =  .06828

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
      exp_25_avg |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |    1.01579   .0274315    37.03   0.000     .9601567    1.071424
           _cons |   -.006101   .0088407    -0.69   0.495    -.0240309    .0118288
----------------------------------------------------------------------------------

. reg exp_50_avg expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1577.33
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9593
                                                       Root MSE      =  .06355

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
      exp_50_avg |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   .9997378   .0251724    39.72   0.000     .9486858     1.05079
           _cons |   .0002669   .0080725     0.03   0.974     -.016105    .0166387
----------------------------------------------------------------------------------

. reg exp_75_avg expectedgovshare if party!=0, vce(cluster govno);

Linear regression                                      Number of obs =      94
                                                       F(  1,    36) = 1667.94
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.9603
                                                       Root MSE      =  .06246

                                     (Std. Err. adjusted for 37 clusters in govno)
----------------------------------------------------------------------------------
                 |               Robust
      exp_75_avg |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
expectedgovshare |   .9948336    .024359    40.84   0.000     .9454311    1.044236
           _cons |   .0022905    .007809     0.29   0.771     -.013547    .0181279
----------------------------------------------------------------------------------

. log close;
      name:  <unnamed>
       log:  C:\Users\cristb\Portfolio allocation France\Replication materials\stata_table2.log
  log type:  text
 closed on:  18 Mar 2016, 11:38:11
--------------------------------------------------------------------------------------------
